<?php
/**
* List all transaction for a given imported file
*
* @author       Fabrice Douteaud <clearbudget@douteaud.com>
* @package      actions
* @access       public
*/

/***********************************************************************

  Copyright (C) 2008  Fabrice douteaud (clearbudget@douteaud.com)

    This file is part of ClearBudget.

    ClearBudget is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    ClearBudget is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with ClearBudget.  If not, see <http://www.gnu.org/licenses/>.


************************************************************************/
//prevent direct access
if(!defined('ENGINEON')) die('Direct access forbidden');

$db = class_db::getInstance();

// get the debit flag
$importId = $context->id;

// get the import file details
$db->addFields('id');
$db->addFields('originalFileName');
$db->addFields('importCount');
$db->addFields('importDuplicate');
$db->addFields('importDate');
$db->addWhere('id', '=', $importId);
// execute
$count = $db->select('t_imports', true);
$importDetails = $db->fetchRow();

// get all related transactions
$db->addFields('amount');
$db->addFields('operationDate');
$db->addFields('debit');
$db->addFields('payee');
$db->addFields('memo');
$db->addWhere('importId', '=', $importId);
$db->select('t_items');
$transactions = $db->fetchAllRows();
?>